class Offers < ActiveRecord::Migration

  def self.up
    create_table "offers", :id => true do |t|
			t.column "region_id", :integer
			t.column "solarsystem_id", :integer
			t.column "station_id", :integer
			t.column "price", :float
      t.column "item_id", :integer
	  t.column "sell", :bool
			t.column "volume_min", :integer
			t.column "volume_remain", :integer
			t.column "volume_enter", :integer
			t.column "issued", :date
			t.column "duration", :integer
			t.column "range", :integer
			t.column "reported", :datetime
			t.column "expires", :date
    end
  end

  def self.down
    drop_table :prices
  end
end
